| 300 |
How do I change the cell's foreground color
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "C1" to Nothing Send Destroy to hoColumns Variant voColumns1 Get ComColumns to voColumns1 Handle hoColumns1 Get Create (RefClass(cComColumns)) to hoColumns1 Set pvComObject of hoColumns1 to voColumns1 Get ComAdd of hoColumns1 "C2" to Nothing Send Destroy to hoColumns1 Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Cell 1" to h Set ComCellValue of hoItems h 1 to "Cell 2" Set ComCellForeColor of hoItems h 1 to (RGB(255,0,0)) Send Destroy to hoItems End_Procedure |
| 299 |
How do I change the visual effect for the cell, using your EBN files
|
| 298 |
How do I change the cell's background color
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "C1" to Nothing Send Destroy to hoColumns Variant voColumns1 Get ComColumns to voColumns1 Handle hoColumns1 Get Create (RefClass(cComColumns)) to hoColumns1 Set pvComObject of hoColumns1 to voColumns1 Get ComAdd of hoColumns1 "C2" to Nothing Send Destroy to hoColumns1 Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Cell 1" to h Set ComCellValue of hoItems h 1 to "Cell 2" Set ComCellBackColor of hoItems h 1 to (RGB(255,0,0)) Send Destroy to hoItems End_Procedure |
| 297 |
How do I change the caption or value for a particular cell
|
| 296 |
How do I get the handle of the cell
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Root 1" to h Get ComInsertItem of hoItems h "Child 1" to Nothing Get ComInsertItem of hoItems h "Child 2" to Nothing Set ComExpandItem of hoItems h to True Set ComCellBold of hoItems (ComItemCell(hoItems,h,0)) to True Send Destroy to hoItems End_Procedure |
| 295 |
How do I retrieve the focused item
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Root 1" to h Get ComInsertItem of hoItems h "Child 1" to Nothing Get ComInsertItem of hoItems h "Child 2" to Nothing Set ComExpandItem of hoItems h to True Set ComItemBold of hoItems (ComFocusItem(hoItems)) to True Send Destroy to hoItems End_Procedure |
| 294 |
How do I get the number or count of child items
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Root 1" to h Get ComInsertItem of hoItems h "Child 1" to Nothing Get ComInsertItem of hoItems h "Child 2" to Nothing Set ComExpandItem of hoItems h to True Get ComAddItem of hoItems (ComChildCount(hoItems,h)) to Nothing Send Destroy to hoItems End_Procedure |
| 293 |
How do I enumerate the visible items
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Root 1" to h Get ComInsertItem of hoItems h "Child 1" to Nothing Get ComInsertItem of hoItems h "Child 2" to Nothing Set ComExpandItem of hoItems h to True Get ComAddItem of hoItems "Root 2" to h Set ComItemBold of hoItems (ComFirstVisibleItem(hoItems)) to True Set ComItemBold of hoItems (ComNextVisibleItem(hoItems,(ComFirstVisibleItem(hoItems)))) to True Send Destroy to hoItems End_Procedure |
| 292 |
How do I enumerate the siblings items
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Root 1" to h Get ComInsertItem of hoItems h "Child 1" to Nothing Get ComInsertItem of hoItems h "Child 2" to Nothing Set ComExpandItem of hoItems h to True Get ComAddItem of hoItems "Root 2" to h Set ComItemBold of hoItems (ComNextSiblingItem(hoItems,(ComFirstVisibleItem(hoItems)))) to True Set ComItemBold of hoItems (ComPrevSiblingItem(hoItems,(ComNextSiblingItem(hoItems,(ComFirstVisibleItem(hoItems)))))) to True Send Destroy to hoItems End_Procedure |
| 291 |
How do I get the parent item
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Root 1" to h Get ComInsertItem of hoItems h "Child 1" to Nothing Get ComInsertItem of hoItems h "Child 2" to Nothing Set ComExpandItem of hoItems h to True Set ComItemBold of hoItems (ComItemParent(hoItems,(ComItemChild(hoItems,h)))) to True Send Destroy to hoItems End_Procedure |
| 290 |
How do I get the first child item
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Root 1" to h Get ComInsertItem of hoItems h "Child 1" to Nothing Get ComInsertItem of hoItems h "Child 2" to Nothing Set ComExpandItem of hoItems h to True Set ComItemBold of hoItems (ComItemChild(hoItems,h)) to True Send Destroy to hoItems End_Procedure |
| 289 |
How do I enumerate the root items
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Root 1" to h Get ComInsertItem of hoItems h "Child 1" to Nothing Get ComInsertItem of hoItems h "Child 2" to Nothing Set ComExpandItem of hoItems h to True Get ComAddItem of hoItems "Root 2" to h Get ComInsertItem of hoItems h "Child 1" to Nothing Get ComInsertItem of hoItems h "Child 2" to Nothing Set ComItemBold of hoItems (ComRootItem(hoItems,0)) to True Set ComItemUnderline of hoItems (ComRootItem(hoItems,1)) to True Send Destroy to hoItems End_Procedure |
| 288 |
I have a hierarchy, how can I count the number of root items
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Root 1" to h Get ComInsertItem of hoItems h "Child 1" to Nothing Get ComInsertItem of hoItems h "Child 2" to Nothing Set ComExpandItem of hoItems h to True Get ComAddItem of hoItems "Root 2" to h Get ComInsertItem of hoItems h "Child 1" to Nothing Get ComInsertItem of hoItems h "Child 2" to Nothing Get ComAddItem of hoItems (ComRootCount(hoItems)) to Nothing Send Destroy to hoItems End_Procedure |
| 287 |
How can I make an item unselectable, or not selectable
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Column" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "unselectable - you can't get selected" to h Set ComSelectableItem of hoItems h to False Get ComAddItem of hoItems "selectable" to Nothing Send Destroy to hoItems End_Procedure |
| 286 |
How can I hide or show an item
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Column" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "hidden" to h Set ComItemHeight of hoItems h to 0 Set ComSelectableItem of hoItems h to False Get ComAddItem of hoItems "visible" to Nothing Send Destroy to hoItems End_Procedure |
| 285 |
How can I change the height for all items
|
| 284 |
How do I change the height of an item
Procedure OnCreate Forward Send OnCreate Set ComScrollBySingleLine to True Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Set ComItemHeight of hoItems (ComAddItem(hoItems,"height")) to 128 Send Destroy to hoItems Variant voItems1 Get ComItems to voItems1 Handle hoItems1 Get Create (RefClass(cComItems)) to hoItems1 Set pvComObject of hoItems1 to voItems1 Get ComAddItem of hoItems1 "enabled" to Nothing Send Destroy to hoItems1 End_Procedure |
| 283 |
How do I disable or enable an item
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Set ComEnableItem of hoItems (ComAddItem(hoItems,"disabled")) to False Send Destroy to hoItems Variant voItems1 Get ComItems to voItems1 Handle hoItems1 Get Create (RefClass(cComItems)) to hoItems1 Set pvComObject of hoItems1 to voItems1 Get ComAddItem of hoItems1 "enabled" to Nothing Send Destroy to hoItems1 End_Procedure |
| 282 |
How do I display as strikeout a cell
|
| 281 |
How do I display as strikeout a cell or an item
|
| 280 |
How do I display as strikeout an item
|
| 279 |
How do I underline a cell
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Set ComCellUnderline of hoItems (ComAddItem(hoItems,"underline")) 0 to True Send Destroy to hoItems End_Procedure |
| 278 |
How do I underline a cell or an item
|
| 277 |
How do I underline an item
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Set ComItemUnderline of hoItems (ComAddItem(hoItems,"underline")) to True Send Destroy to hoItems End_Procedure |
| 276 |
How do I display as italic a cell
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Set ComCellItalic of hoItems (ComAddItem(hoItems,"italic")) 0 to True Send Destroy to hoItems End_Procedure |
| 275 |
How do I display as italic a cell or an item
|
| 274 |
How do I display as italic an item
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Set ComItemItalic of hoItems (ComAddItem(hoItems,"italic")) to True Send Destroy to hoItems End_Procedure |
| 273 |
How do I bold a cell
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Set ComCellBold of hoItems (ComAddItem(hoItems,"bold")) 0 to True Send Destroy to hoItems End_Procedure |
| 272 |
How do I bold a cell or an item
|
| 271 |
How do I bold an item
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Set ComItemBold of hoItems (ComAddItem(hoItems,"bold")) to True Send Destroy to hoItems End_Procedure |
| 270 |
How do I change the foreground color for the item
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Root" to h Variant hC Get ComInsertItem of hoItems h "Child 1" to hC Set ComItemForeColor of hoItems hC to (RGB(255,0,0)) Get ComInsertItem of hoItems h "Child 2" to Nothing Set ComExpandItem of hoItems h to True Send Destroy to hoItems End_Procedure |
| 269 |
How do I change the visual appearance for the item, using your EBN technology
|
| 268 |
How do I change the background color for the item
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Root" to h Variant hC Get ComInsertItem of hoItems h "Child 1" to hC Set ComItemBackColor of hoItems hC to (RGB(255,0,0)) Get ComInsertItem of hoItems h "Child 2" to Nothing Set ComExpandItem of hoItems h to True Send Destroy to hoItems End_Procedure |
| 267 |
How do I expand or collapse an item
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Root" to h Get ComInsertItem of hoItems h "Child 1" to Nothing Get ComInsertItem of hoItems h "Child 2" to Nothing Set ComExpandItem of hoItems h to True Send Destroy to hoItems End_Procedure |
| 266 |
How do I associate an extra data to an item
|
| 265 |
How do I get the number or count of items
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Root" to h Get ComInsertItem of hoItems h "Child 1" to Nothing Get ComInsertItem of hoItems h "Child 2" to Nothing Set ComExpandItem of hoItems h to True Send Destroy to hoItems Variant voItems1 Get ComItems to voItems1 Handle hoItems1 Get Create (RefClass(cComItems)) to hoItems1 Set pvComObject of hoItems1 to voItems1 Get ComAddItem of hoItems1 (ComItemCount(hoItems1)) to Nothing Send Destroy to hoItems1 End_Procedure |
| 264 |
How can I specify the width of the ActiveX control, when using the InsertControlItem property
Procedure OnCreate Forward Send OnCreate Set ComScrollBySingleLine to False Set ComTreeColumnIndex to 1 Set ComDrawGridLines to OLEexAllLines Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "C1" to Nothing Send Destroy to hoColumns Variant voColumns1 Get ComColumns to voColumns1 Handle hoColumns1 Get Create (RefClass(cComColumns)) to hoColumns1 Set pvComObject of hoColumns1 to voColumns1 Get ComAdd of hoColumns1 "C2" to Nothing Send Destroy to hoColumns1 Variant voColumns2 Get ComColumns to voColumns2 Handle hoColumns2 Get Create (RefClass(cComColumns)) to hoColumns2 Set pvComObject of hoColumns2 to voColumns2 Get ComAdd of hoColumns2 "C3" to Nothing Send Destroy to hoColumns2 Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComInsertControlItem of hoItems "MSCAL.Calendar" Nothing to h Set ComItemWidth of hoItems h to 128 Set ComCellValue of hoItems h 0 to "This is a bit of text that is shown in the first column" Set ComCellSingleLine of hoItems h 0 to False Set ComCellValue of hoItems h 2 to "This is a bit of text that is shown in the third column" Set ComCellSingleLine of hoItems h 2 to False Send Destroy to hoItems End_Procedure |
| 263 |
How can I put the ActiveX control in a different column, when using the InsertControlItem property
Procedure OnCreate Forward Send OnCreate Set ComScrollBySingleLine to False Set ComDrawGridLines to OLEexAllLines Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "C1" to Nothing Send Destroy to hoColumns Variant voColumns1 Get ComColumns to voColumns1 Handle hoColumns1 Get Create (RefClass(cComColumns)) to hoColumns1 Set pvComObject of hoColumns1 to voColumns1 Get ComAdd of hoColumns1 "C2" to Nothing Send Destroy to hoColumns1 Variant voColumns2 Get ComColumns to voColumns2 Handle hoColumns2 Get Create (RefClass(cComColumns)) to hoColumns2 Set pvComObject of hoColumns2 to voColumns2 Get ComAdd of hoColumns2 "C3" to Nothing Send Destroy to hoColumns2 Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComInsertControlItem of hoItems "MSCAL.Calendar" Nothing to h Set ComCellValue of hoItems h 0 to "This is a bit of text that is shown in the first column" Set ComCellSingleLine of hoItems h 0 to False Set ComItemWidth of hoItems h to -32001 Set ComCellValue of hoItems h 2 to "This is a bit of text that is shown in the third column" Set ComCellSingleLine of hoItems h 2 to False Send Destroy to hoItems End_Procedure |
| 262 |
Is there any function I can use to get the program or the control identifier I've been using when called the InsertControlItem
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Set ComScrollBySingleLine to False Set ComLinesAtRoot to OLEexLinesAtRoot Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComInsertControlItem of hoItems "MSCAL.Calendar" Nothing to h Get ComInsertItem of hoItems h (ComItemControlID(hoItems,h)) to Nothing Set ComExpandItem of hoItems h to True Get ComInsertControlItem of hoItems "MSChart20Lib.MSChart" Nothing to h Set ComItemAppearance of hoItems h to OLEEtched Get ComInsertItem of hoItems h (ComItemControlID(hoItems,h)) to Nothing Set ComExpandItem of hoItems h to True Send Destroy to hoItems End_Procedure |
| 261 |
How can I change the height of newly created ActiveX control, using the InsertControlItem
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Set ComScrollBySingleLine to False Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Set ComItemHeight of hoItems (ComInsertControlItem(hoItems,,"MSCAL.Calendar",Nothing)) to 64 Set ComItemAppearance of hoItems (ComInsertControlItem(hoItems,,"MSChart20Lib.MSChart",Nothing)) to OLEEtched Send Destroy to hoItems End_Procedure |
| 260 |
How can I change the border for newly created ActiveX control, using the InsertControlItem
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Set ComScrollBySingleLine to False Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Set ComItemAppearance of hoItems (ComInsertControlItem(hoItems,,"MSCAL.Calendar",Nothing)) to OLESunken Set ComItemAppearance of hoItems (ComInsertControlItem(hoItems,,"MSChart20Lib.MSChart",Nothing)) to OLEEtched Send Destroy to hoItems End_Procedure |
| 259 |
How can I access the properties and methods for an ActiveX control that I've just added using the InsertControlItem
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Root" to h Variant voCalendar Get ComItemObject of hoItems (ComInsertControlItem(hoItems,h,"MSCAL.Calendar",Nothing)) to voCalendar Handle hoCalendar Get Create (RefClass(cComCalendar)) to hoCalendar Set pvComObject of hoCalendar to voCalendar Set ComBackColor of hoCalendar to (RGB(255,255,255)) Set ComGridCellEffect of hoCalendar to 0 Set ComShowTitle of hoCalendar to False Set ComShowDateSelectors of hoCalendar to False Send Destroy to hoCalendar Set ComExpandItem of hoItems h to True Send Destroy to hoItems End_Procedure |
| 258 |
How can I access the properties and methods for an ActiveX control that I've just added using the InsertControlItem
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Root" to h Variant voCalendar Get ComItemObject of hoItems (ComInsertControlItem(hoItems,h,"MSCAL.Calendar",Nothing)) to voCalendar Handle hoCalendar Get Create (RefClass(cComCalendar)) to hoCalendar Set pvComObject of hoCalendar to voCalendar Set ComBackColor of hoCalendar to (RGB(255,255,255)) Send Destroy to hoCalendar Set ComExpandItem of hoItems h to True Send Destroy to hoItems End_Procedure |
| 257 |
How can I insert an ActiveX control
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Root" to h Get ComInsertControlItem of hoItems h "MSCAL.Calendar" Nothing to Nothing Set ComExpandItem of hoItems h to True Send Destroy to hoItems End_Procedure |
| 256 |
How can I change at runtime the parent of the item
|
| 255 |
How can I sort the items
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Root" to h Get ComInsertItem of hoItems h "Child 1" to Nothing Get ComInsertItem of hoItems h "Child 2" to Nothing Set ComExpandItem of hoItems h to True Send Destroy to hoItems Variant voColumns1 Get ComColumns to voColumns1 Handle hoColumns1 Get Create (RefClass(cComColumns)) to hoColumns1 Set pvComObject of hoColumns1 to voColumns1 Variant voColumn Get ComItem of hoColumns1 "Default" to voColumn Handle hoColumn Get Create (RefClass(cComColumn)) to hoColumn Set pvComObject of hoColumn to voColumn Set ComSortOrder of hoColumn to OLESortDescending Send Destroy to hoColumn Send Destroy to hoColumns1 End_Procedure |
| 254 |
How do I sort the child items
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Root" to h Get ComInsertItem of hoItems h "Child 1" to Nothing Get ComInsertItem of hoItems h "Child 2" to Nothing Set ComExpandItem of hoItems h to True Send ComSortChildren of hoItems h 0 False Send Destroy to hoItems End_Procedure |
| 253 |
How can I ensure or scroll the control so the item fits the control's client area
|
| 252 |
How can I remove or delete all items
|
| 251 |
How can I remove or delete an item
|
| 250 |
How can I add or insert child items
Procedure OnCreate Forward Send OnCreate Set ComLinesAtRoot to OLEexLinesAtRoot Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "C1" to Nothing Send Destroy to hoColumns Variant voColumns1 Get ComColumns to voColumns1 Handle hoColumns1 Get Create (RefClass(cComColumns)) to hoColumns1 Set pvComObject of hoColumns1 to voColumns1 Get ComAdd of hoColumns1 "C2" to Nothing Send Destroy to hoColumns1 Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Cell 1" to h Set ComCellValue of hoItems h 1 to "Cell 2" Set ComCellValue of hoItems (ComInsertItem(hoItems,h,"Cell 3")) 1 to "Cell 4" Set ComCellValue of hoItems (ComInsertItem(hoItems,h,"Cell 5")) 1 to "Cell 6" Set ComExpandItem of hoItems h to True Send Destroy to hoItems End_Procedure |
| 249 |
How can I add or insert a child item
Procedure OnCreate Forward Send OnCreate Set ComLinesAtRoot to OLEexLinesAtRoot Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Get ComInsertItem of hoItems (ComAddItem(hoItems,"root")) "child" to Nothing Send Destroy to hoItems End_Procedure |
| 248 |
How can I add or insert an item
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "C1" to Nothing Send Destroy to hoColumns Variant voColumns1 Get ComColumns to voColumns1 Handle hoColumns1 Get Create (RefClass(cComColumns)) to hoColumns1 Set pvComObject of hoColumns1 to voColumns1 Get ComAdd of hoColumns1 "C2" to Nothing Send Destroy to hoColumns1 Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Set ComCellValue of hoItems (ComAddItem(hoItems,"Cell 1")) 1 to "Cell 2" Variant h Get ComAddItem of hoItems "Cell 3" to h Set ComCellValue of hoItems h 1 to "Cell 4" Send Destroy to hoItems End_Procedure |
| 247 |
How can I add or insert an item
|
| 246 |
How can I get the columns as they are shown in the control's sortbar
|
| 245 |
How can I access the properties of a column
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "A" to Nothing Send Destroy to hoColumns Variant voColumns1 Get ComColumns to voColumns1 Handle hoColumns1 Get Create (RefClass(cComColumns)) to hoColumns1 Set pvComObject of hoColumns1 to voColumns1 Variant voColumn Get ComItem of hoColumns1 "A" to voColumn Handle hoColumn Get Create (RefClass(cComColumn)) to hoColumn Set pvComObject of hoColumn to voColumn Set ComHeaderBold of hoColumn to True Send Destroy to hoColumn Send Destroy to hoColumns1 End_Procedure |
| 244 |
How can I remove all the columns
|
| 243 |
How can I remove a column
|
| 242 |
How can I get the number or the count of columns
|
| 241 |
How can I change the font for all cells in the entire column
Procedure OnCreate Forward Send OnCreate Variant f Get Comcreateobject "StdFont" to f Set ComName to "Tahoma" Set ComSize to 12 Variant voConditionalFormats Get ComConditionalFormats to voConditionalFormats Handle hoConditionalFormats Get Create (RefClass(cComConditionalFormats)) to hoConditionalFormats Set pvComObject of hoConditionalFormats to voConditionalFormats Variant voConditionalFormat Get ComAdd of hoConditionalFormats "1" Nothing to voConditionalFormat Handle hoConditionalFormat Get Create (RefClass(cComConditionalFormat)) to hoConditionalFormat Set pvComObject of hoConditionalFormat to voConditionalFormat Set ComFont of hoConditionalFormat to f Set ComApplyTo of hoConditionalFormat to OLEexFormatToColumns Send Destroy to hoConditionalFormat Send Destroy to hoConditionalFormats Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Column" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Get ComAddItem of hoItems 0 to Nothing Send Destroy to hoItems Variant voItems1 Get ComItems to voItems1 Handle hoItems1 Get Create (RefClass(cComItems)) to hoItems1 Set pvComObject of hoItems1 to voItems1 Get ComAddItem of hoItems1 1 to Nothing Send Destroy to hoItems1 End_Procedure |
| 240 |
How can I change the background color for all cells in the column
Procedure OnCreate Forward Send OnCreate Variant v Variant voConditionalFormats Get ComConditionalFormats to voConditionalFormats Handle hoConditionalFormats Get Create (RefClass(cComConditionalFormats)) to hoConditionalFormats Set pvComObject of hoConditionalFormats to voConditionalFormats Get ComAdd of hoConditionalFormats "1" Nothing to v Send Destroy to hoConditionalFormats Variant var_ConditionalFormat Move v to var_ConditionalFormat Set ComBackColor to (RGB(255,0,0)) Set ComApplyTo to OLEexFormatToColumns Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Column" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Get ComAddItem of hoItems 0 to Nothing Send Destroy to hoItems Variant voItems1 Get ComItems to voItems1 Handle hoItems1 Get Create (RefClass(cComItems)) to hoItems1 Set pvComObject of hoItems1 to voItems1 Get ComAddItem of hoItems1 1 to Nothing Send Destroy to hoItems1 End_Procedure |
| 239 |
How can I change the foreground color for all cells in the column
Procedure OnCreate Forward Send OnCreate Variant v Variant voConditionalFormats Get ComConditionalFormats to voConditionalFormats Handle hoConditionalFormats Get Create (RefClass(cComConditionalFormats)) to hoConditionalFormats Set pvComObject of hoConditionalFormats to voConditionalFormats Get ComAdd of hoConditionalFormats "1" Nothing to v Send Destroy to hoConditionalFormats Variant var_ConditionalFormat Move v to var_ConditionalFormat Set ComForeColor to (RGB(255,0,0)) Set ComApplyTo to OLEexFormatToColumns Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Column" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Get ComAddItem of hoItems 0 to Nothing Send Destroy to hoItems Variant voItems1 Get ComItems to voItems1 Handle hoItems1 Get Create (RefClass(cComItems)) to hoItems1 Set pvComObject of hoItems1 to voItems1 Get ComAddItem of hoItems1 1 to Nothing Send Destroy to hoItems1 End_Procedure |
| 238 |
How can I show as strikeout all cells in the column
Procedure OnCreate Forward Send OnCreate Variant v Variant voConditionalFormats Get ComConditionalFormats to voConditionalFormats Handle hoConditionalFormats Get Create (RefClass(cComConditionalFormats)) to hoConditionalFormats Set pvComObject of hoConditionalFormats to voConditionalFormats Get ComAdd of hoConditionalFormats "1" Nothing to v Send Destroy to hoConditionalFormats Variant var_ConditionalFormat Move v to var_ConditionalFormat Set ComStrikeOut to True Set ComApplyTo to OLEexFormatToColumns Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Column" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Get ComAddItem of hoItems 0 to Nothing Send Destroy to hoItems Variant voItems1 Get ComItems to voItems1 Handle hoItems1 Get Create (RefClass(cComItems)) to hoItems1 Set pvComObject of hoItems1 to voItems1 Get ComAddItem of hoItems1 1 to Nothing Send Destroy to hoItems1 End_Procedure |
| 237 |
How can I underline all cells in the column
Procedure OnCreate Forward Send OnCreate Variant v Variant voConditionalFormats Get ComConditionalFormats to voConditionalFormats Handle hoConditionalFormats Get Create (RefClass(cComConditionalFormats)) to hoConditionalFormats Set pvComObject of hoConditionalFormats to voConditionalFormats Get ComAdd of hoConditionalFormats "1" Nothing to v Send Destroy to hoConditionalFormats Variant var_ConditionalFormat Move v to var_ConditionalFormat Set ComUnderline to True Set ComApplyTo to OLEexFormatToColumns Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Column" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Get ComAddItem of hoItems 0 to Nothing Send Destroy to hoItems Variant voItems1 Get ComItems to voItems1 Handle hoItems1 Get Create (RefClass(cComItems)) to hoItems1 Set pvComObject of hoItems1 to voItems1 Get ComAddItem of hoItems1 1 to Nothing Send Destroy to hoItems1 End_Procedure |
| 236 |
How can I show in italic all data in the column
Procedure OnCreate Forward Send OnCreate Variant v Variant voConditionalFormats Get ComConditionalFormats to voConditionalFormats Handle hoConditionalFormats Get Create (RefClass(cComConditionalFormats)) to hoConditionalFormats Set pvComObject of hoConditionalFormats to voConditionalFormats Get ComAdd of hoConditionalFormats "1" Nothing to v Send Destroy to hoConditionalFormats Variant var_ConditionalFormat Move v to var_ConditionalFormat Set ComItalic to True Set ComApplyTo to OLEexFormatToColumns Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Column" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Get ComAddItem of hoItems 0 to Nothing Send Destroy to hoItems Variant voItems1 Get ComItems to voItems1 Handle hoItems1 Get Create (RefClass(cComItems)) to hoItems1 Set pvComObject of hoItems1 to voItems1 Get ComAddItem of hoItems1 1 to Nothing Send Destroy to hoItems1 End_Procedure |
| 235 |
How can I bold the entire column
Procedure OnCreate Forward Send OnCreate Variant v Variant voConditionalFormats Get ComConditionalFormats to voConditionalFormats Handle hoConditionalFormats Get Create (RefClass(cComConditionalFormats)) to hoConditionalFormats Set pvComObject of hoConditionalFormats to voConditionalFormats Get ComAdd of hoConditionalFormats "1" Nothing to v Send Destroy to hoConditionalFormats Variant var_ConditionalFormat Move v to var_ConditionalFormat Set ComBold to True Set ComApplyTo to OLEexFormatToColumns Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Column" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Get ComAddItem of hoItems 0 to Nothing Send Destroy to hoItems Variant voItems1 Get ComItems to voItems1 Handle hoItems1 Get Create (RefClass(cComItems)) to hoItems1 Set pvComObject of hoItems1 to voItems1 Get ComAddItem of hoItems1 1 to Nothing Send Destroy to hoItems1 End_Procedure |
| 234 |
How can I display a computed column and highlight some values that are negative or less than a value
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "A" to Nothing Send Destroy to hoColumns Variant voColumns1 Get ComColumns to voColumns1 Handle hoColumns1 Get Create (RefClass(cComColumns)) to hoColumns1 Set pvComObject of hoColumns1 to voColumns1 Get ComAdd of hoColumns1 "B" to Nothing Send Destroy to hoColumns1 Variant voColumns2 Get ComColumns to voColumns2 Handle hoColumns2 Get Create (RefClass(cComColumns)) to hoColumns2 Set pvComObject of hoColumns2 to voColumns2 Variant voColumn Get ComAdd of hoColumns2 "(A+B)*1.19" to voColumn Handle hoColumn Get Create (RefClass(cComColumn)) to hoColumn Set pvComObject of hoColumn to voColumn Set ComComputedField of hoColumn to "(dbl(%0) + dbl(%1)) * 1.19" Send Destroy to hoColumn Send Destroy to hoColumns2 Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Set ComCellValue of hoItems (ComAddItem(hoItems,1)) 1 to 2 Send Destroy to hoItems Variant voItems1 Get ComItems to voItems1 Handle hoItems1 Get Create (RefClass(cComItems)) to hoItems1 Set pvComObject of hoItems1 to voItems1 Set ComCellValue of hoItems1 (ComAddItem(hoItems1,10)) 1 to 20 Send Destroy to hoItems1 Variant v Variant voConditionalFormats Get ComConditionalFormats to voConditionalFormats Handle hoConditionalFormats Get Create (RefClass(cComConditionalFormats)) to hoConditionalFormats Set pvComObject of hoConditionalFormats to voConditionalFormats Get ComAdd of hoConditionalFormats "dbl(%2) > 10" Nothing to v Send Destroy to hoConditionalFormats Variant var_ConditionalFormat Move v to var_ConditionalFormat Set ComBold to True Set ComForeColor to (RGB(255,0,0)) Set ComApplyTo to |CI$2 End_Procedure |
| 233 |
Can I display a computed column so it displays the VAT, or SUM
|
| 232 |
How can I show a column that adds values in the cells
|
| 231 |
Is there any function to filter the control's data as I type, so the items being displayed include the typed characters
Procedure OnCreate Forward Send OnCreate Variant v Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Filter" to v Send Destroy to hoColumns Variant var_Column Move v to var_Column Set ComFilterOnType to True Set ComDisplayFilterButton to True Set ComAutoSearch to OLEexContains Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Get ComAddItem of hoItems "Canada" to Nothing Send Destroy to hoItems Variant voItems1 Get ComItems to voItems1 Handle hoItems1 Get Create (RefClass(cComItems)) to hoItems1 Set pvComObject of hoItems1 to voItems1 Get ComAddItem of hoItems1 "USA" to Nothing Send Destroy to hoItems1 End_Procedure |
| 230 |
Is there any function to filter the control's data as I type, something like filter on type
Procedure OnCreate Forward Send OnCreate Variant v Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Filter" to v Send Destroy to hoColumns Variant var_Column Move v to var_Column Set ComFilterOnType to True Set ComDisplayFilterButton to True Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Get ComAddItem of hoItems "Canada" to Nothing Send Destroy to hoItems Variant voItems1 Get ComItems to voItems1 Handle hoItems1 Get Create (RefClass(cComItems)) to hoItems1 Set pvComObject of hoItems1 to voItems1 Get ComAddItem of hoItems1 "USA" to Nothing Send Destroy to hoItems1 End_Procedure |
| 229 |
How can I programmatically filter a column
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Variant voColumn Get ComAdd of hoColumns "Filter" to voColumn Handle hoColumn Get Create (RefClass(cComColumn)) to hoColumn Set pvComObject of hoColumn to voColumn Set ComDisplayFilterButton of hoColumn to True Set ComFilterType of hoColumn to OLEexNonBlanks Send Destroy to hoColumn Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Get ComAddItem of hoItems Nothing to Nothing Send Destroy to hoItems Variant voItems1 Get ComItems to voItems1 Handle hoItems1 Get Create (RefClass(cComItems)) to hoItems1 Set pvComObject of hoItems1 to voItems1 Get ComAddItem of hoItems1 "not empty" to Nothing Send Destroy to hoItems1 Send ComApplyFilter End_Procedure |
| 228 |
How can I show or display the control's filter
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Variant voColumn Get ComAdd of hoColumns "Filter" to voColumn Handle hoColumn Get Create (RefClass(cComColumn)) to hoColumn Set pvComObject of hoColumn to voColumn Set ComDisplayFilterButton of hoColumn to True Send Destroy to hoColumn Send Destroy to hoColumns End_Procedure |
| 227 |
How can I customize the items being displayed in the drop down filter window
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Variant voColumn Get ComAdd of hoColumns "Custom Filter" to voColumn Handle hoColumn Get Create (RefClass(cComColumn)) to hoColumn Set pvComObject of hoColumn to voColumn Set ComDisplayFilterButton of hoColumn to True Set ComDisplayFilterPattern of hoColumn to False Set ComCustomFilter of hoColumn to "Excel Spreadsheets (*.xls )||*.xls|||Word Documents||*.doc|||Powerpoint Presentations||*.pps|||Text Documents (*.log,*.txt)||*.txt|*.log" Set ComFilterType of hoColumn to OLEexPattern Set ComFilter of hoColumn to "*.xls" Send Destroy to hoColumn Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Get ComAddItem of hoItems "excel.xls" to Nothing Send Destroy to hoItems Variant voItems1 Get ComItems to voItems1 Handle hoItems1 Get Create (RefClass(cComItems)) to hoItems1 Set pvComObject of hoItems1 to voItems1 Get ComAddItem of hoItems1 "word.doc" to Nothing Send Destroy to hoItems1 Variant voItems2 Get ComItems to voItems2 Handle hoItems2 Get Create (RefClass(cComItems)) to hoItems2 Set pvComObject of hoItems2 to voItems2 Get ComAddItem of hoItems2 "pp.pps" to Nothing Send Destroy to hoItems2 Variant voItems3 Get ComItems to voItems3 Handle hoItems3 Get Create (RefClass(cComItems)) to hoItems3 Set pvComObject of hoItems3 to voItems3 Get ComAddItem of hoItems3 "text.txt" to Nothing Send Destroy to hoItems3 Send ComApplyFilter End_Procedure |
| 226 |
How can I change the order or the position of the columns in the sort bar
Procedure OnCreate Forward Send OnCreate Set ComSortBarVisible to True Set ComSortBarColumnWidth to 48 Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Variant voColumn Get ComAdd of hoColumns "C1" to voColumn Handle hoColumn Get Create (RefClass(cComColumn)) to hoColumn Set pvComObject of hoColumn to voColumn Set ComSortOrder of hoColumn to OLESortAscending Send Destroy to hoColumn Send Destroy to hoColumns Variant voColumns1 Get ComColumns to voColumns1 Handle hoColumns1 Get Create (RefClass(cComColumns)) to hoColumns1 Set pvComObject of hoColumns1 to voColumns1 Variant voColumn1 Get ComAdd of hoColumns1 "C2" to voColumn1 Handle hoColumn1 Get Create (RefClass(cComColumn)) to hoColumn1 Set pvComObject of hoColumn1 to voColumn1 Set ComSortOrder of hoColumn1 to OLESortDescending Send Destroy to hoColumn1 Send Destroy to hoColumns1 Variant voColumns2 Get ComColumns to voColumns2 Handle hoColumns2 Get Create (RefClass(cComColumns)) to hoColumns2 Set pvComObject of hoColumns2 to voColumns2 Variant voColumn2 Get ComItem of hoColumns2 "C2" to voColumn2 Handle hoColumn2 Get Create (RefClass(cComColumn)) to hoColumn2 Set pvComObject of hoColumn2 to voColumn2 Set ComSortPosition of hoColumn2 to 0 Send Destroy to hoColumn2 Send Destroy to hoColumns2 End_Procedure |
| 225 |
How do I arrange my columns on multiple levels
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Variant voColumn Get ComAdd of hoColumns "S" to voColumn Handle hoColumn Get Create (RefClass(cComColumn)) to hoColumn Set pvComObject of hoColumn to voColumn Set ComWidth of hoColumn to 32 Send Destroy to hoColumn Send Destroy to hoColumns Variant voColumns1 Get ComColumns to voColumns1 Handle hoColumns1 Get Create (RefClass(cComColumns)) to hoColumns1 Set pvComObject of hoColumns1 to voColumns1 Variant voColumn1 Get ComAdd of hoColumns1 "Level 2" to voColumn1 Handle hoColumn1 Get Create (RefClass(cComColumn)) to hoColumn1 Set pvComObject of hoColumn1 to voColumn1 Set ComLevelKey of hoColumn1 to 1 Send Destroy to hoColumn1 Send Destroy to hoColumns1 Variant voColumns2 Get ComColumns to voColumns2 Handle hoColumns2 Get Create (RefClass(cComColumns)) to hoColumns2 Set pvComObject of hoColumns2 to voColumns2 Variant voColumn2 Get ComAdd of hoColumns2 "Level 3" to voColumn2 Handle hoColumn2 Get Create (RefClass(cComColumn)) to hoColumn2 Set pvComObject of hoColumn2 to voColumn2 Set ComLevelKey of hoColumn2 to 1 Send Destroy to hoColumn2 Send Destroy to hoColumns2 Variant voColumns3 Get ComColumns to voColumns3 Handle hoColumns3 Get Create (RefClass(cComColumns)) to hoColumns3 Set pvComObject of hoColumns3 to voColumns3 Variant voColumn3 Get ComAdd of hoColumns3 "Level 4" to voColumn3 Handle hoColumn3 Get Create (RefClass(cComColumn)) to hoColumn3 Set pvComObject of hoColumn3 to voColumn3 Set ComLevelKey of hoColumn3 to 1 Send Destroy to hoColumn3 Send Destroy to hoColumns3 Variant voColumns4 Get ComColumns to voColumns4 Handle hoColumns4 Get Create (RefClass(cComColumns)) to hoColumns4 Set pvComObject of hoColumns4 to voColumns4 Variant voColumn4 Get ComAdd of hoColumns4 "Level 1" to voColumn4 Handle hoColumn4 Get Create (RefClass(cComColumn)) to hoColumn4 Set pvComObject of hoColumn4 to voColumn4 Set ComLevelKey of hoColumn4 to "2" Send Destroy to hoColumn4 Send Destroy to hoColumns4 Variant voColumns5 Get ComColumns to voColumns5 Handle hoColumns5 Get Create (RefClass(cComColumns)) to hoColumns5 Set pvComObject of hoColumns5 to voColumns5 Variant voColumn5 Get ComAdd of hoColumns5 "Level 2" to voColumn5 Handle hoColumn5 Get Create (RefClass(cComColumn)) to hoColumn5 Set pvComObject of hoColumn5 to voColumn5 Set ComLevelKey of hoColumn5 to "2" Send Destroy to hoColumn5 Send Destroy to hoColumns5 Variant voColumns6 Get ComColumns to voColumns6 Handle hoColumns6 Get Create (RefClass(cComColumns)) to hoColumns6 Set pvComObject of hoColumns6 to voColumns6 Variant voColumn6 Get ComAdd of hoColumns6 "Level 3" to voColumn6 Handle hoColumn6 Get Create (RefClass(cComColumn)) to hoColumn6 Set pvComObject of hoColumn6 to voColumn6 Set ComLevelKey of hoColumn6 to "2" Send Destroy to hoColumn6 Send Destroy to hoColumns6 Variant voColumns7 Get ComColumns to voColumns7 Handle hoColumns7 Get Create (RefClass(cComColumns)) to hoColumns7 Set pvComObject of hoColumns7 to voColumns7 Variant voColumn7 Get ComAdd of hoColumns7 "Level 4" to voColumn7 Handle hoColumn7 Get Create (RefClass(cComColumn)) to hoColumn7 Set pvComObject of hoColumn7 to voColumn7 Set ComLevelKey of hoColumn7 to "2" Send Destroy to hoColumn7 Send Destroy to hoColumns7 Variant voColumns8 Get ComColumns to voColumns8 Handle hoColumns8 Get Create (RefClass(cComColumns)) to hoColumns8 Set pvComObject of hoColumns8 to voColumns8 Variant voColumn8 Get ComAdd of hoColumns8 "E" to voColumn8 Handle hoColumn8 Get Create (RefClass(cComColumn)) to hoColumn8 Set pvComObject of hoColumn8 to voColumn8 Set ComWidth of hoColumn8 to 32 Send Destroy to hoColumn8 Send Destroy to hoColumns8 End_Procedure |
| 224 |
How do I arrange my columns on multiple lines
Procedure OnCreate Forward Send OnCreate Set ComHeaderHeight to 32 Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Variant voColumn Get ComAdd of hoColumns "" to voColumn Handle hoColumn Get Create (RefClass(cComColumn)) to hoColumn Set pvComObject of hoColumn to voColumn Set ComHTMLCaption of hoColumn to "Line 1<br>Line 2" Send Destroy to hoColumn Send Destroy to hoColumns End_Procedure |
| 223 |
How can I display all cells using HTML format
|
| 222 |
How can I display all cells using multiple lines
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Variant voColumn Get ComAdd of hoColumns "MultipleLine" to voColumn Handle hoColumn Get Create (RefClass(cComColumn)) to hoColumn Set pvComObject of hoColumn to voColumn Set ComDef of hoColumn OLEexCellSingleLine to False Send Destroy to hoColumn Send Destroy to hoColumns Variant voColumns1 Get ComColumns to voColumns1 Handle hoColumns1 Get Create (RefClass(cComColumns)) to hoColumns1 Set pvComObject of hoColumns1 to voColumns1 Variant voColumn1 Get ComAdd of hoColumns1 "SingleLine" to voColumn1 Handle hoColumn1 Get Create (RefClass(cComColumn)) to hoColumn1 Set pvComObject of hoColumn1 to voColumn1 Set ComDef of hoColumn1 OLEexCellSingleLine to True Send Destroy to hoColumn1 Send Destroy to hoColumns1 Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Set ComCellValue of hoItems (ComAddItem(hoItems,"This is a bit of long text that should break the line")) 1 to "this is a bit of long text that's displayed on a single line" Send Destroy to hoItems End_Procedure |
| 221 |
How do change the vertical alignment for all cells in the column
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Variant voColumn Get ComAdd of hoColumns "MultipleLine" to voColumn Handle hoColumn Get Create (RefClass(cComColumn)) to hoColumn Set pvComObject of hoColumn to voColumn Set ComDef of hoColumn OLEexCellSingleLine to False Send Destroy to hoColumn Send Destroy to hoColumns Variant voColumns1 Get ComColumns to voColumns1 Handle hoColumns1 Get Create (RefClass(cComColumns)) to hoColumns1 Set pvComObject of hoColumns1 to voColumns1 Variant voColumn1 Get ComAdd of hoColumns1 "VAlign" to voColumn1 Handle hoColumn1 Get Create (RefClass(cComColumn)) to hoColumn1 Set pvComObject of hoColumn1 to voColumn1 Set ComDef of hoColumn1 OLEexCellVAlignment to 2 Send Destroy to hoColumn1 Send Destroy to hoColumns1 Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Set ComCellValue of hoItems (ComAddItem(hoItems,"This is a bit of long text that should break the line")) 1 to "bottom" Send Destroy to hoItems Variant voItems1 Get ComItems to voItems1 Handle hoItems1 Get Create (RefClass(cComItems)) to hoItems1 Set pvComObject of hoItems1 to voItems1 Set ComCellValue of hoItems1 (ComAddItem(hoItems1,"This is a bit of long text that should break the line")) 1 to "bottom" Send Destroy to hoItems1 End_Procedure |
| 220 |
How do change the foreground color for all cells in the column
|
| 219 |
How do change the background color for all cells in the column
|
| 218 |
How do I show buttons for all cells in the column
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Variant voColumn Get ComAdd of hoColumns "Button" to voColumn Handle hoColumn Get Create (RefClass(cComColumn)) to hoColumn Set pvComObject of hoColumn to voColumn Set ComDef of hoColumn OLEexCellHasButton to True Set ComDef of hoColumn OLEexCellButtonAutoWidth to True Send Destroy to hoColumn Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Get ComAddItem of hoItems " Button 1 " to Nothing Send Destroy to hoItems Variant voItems1 Get ComItems to voItems1 Handle hoItems1 Get Create (RefClass(cComItems)) to hoItems1 Set pvComObject of hoItems1 to voItems1 Get ComAddItem of hoItems1 " Button 2 " to Nothing Send Destroy to hoItems1 End_Procedure |
| 217 |
How do I show buttons for all cells in the column
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Variant voColumn Get ComAdd of hoColumns "Button" to voColumn Handle hoColumn Get Create (RefClass(cComColumn)) to hoColumn Set pvComObject of hoColumn to voColumn Set ComDef of hoColumn OLEexCellHasButton to True Send Destroy to hoColumn Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Get ComAddItem of hoItems 0 to Nothing Send Destroy to hoItems Variant voItems1 Get ComItems to voItems1 Handle hoItems1 Get Create (RefClass(cComItems)) to hoItems1 Set pvComObject of hoItems1 to voItems1 Get ComAddItem of hoItems1 1 to Nothing Send Destroy to hoItems1 End_Procedure |
| 216 |
How do I display radio buttons for all cells in the column
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Variant voColumn Get ComAdd of hoColumns "Radio" to voColumn Handle hoColumn Get Create (RefClass(cComColumn)) to hoColumn Set pvComObject of hoColumn to voColumn Set ComDef of hoColumn OLEexCellHasRadioButton to True Send Destroy to hoColumn Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Get ComAddItem of hoItems 0 to Nothing Send Destroy to hoItems Variant voItems1 Get ComItems to voItems1 Handle hoItems1 Get Create (RefClass(cComItems)) to hoItems1 Set pvComObject of hoItems1 to voItems1 Get ComAddItem of hoItems1 1 to Nothing Send Destroy to hoItems1 End_Procedure |
| 215 |
How do I display checkboxes for all cells in the column
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Variant voColumn Get ComAdd of hoColumns "Check" to voColumn Handle hoColumn Get Create (RefClass(cComColumn)) to hoColumn Set pvComObject of hoColumn to voColumn Set ComDef of hoColumn OLEexCellHasCheckBox to True Send Destroy to hoColumn Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Get ComAddItem of hoItems 0 to Nothing Send Destroy to hoItems Variant voItems1 Get ComItems to voItems1 Handle hoItems1 Get Create (RefClass(cComItems)) to hoItems1 Set pvComObject of hoItems1 to voItems1 Get ComAddItem of hoItems1 1 to Nothing Send Destroy to hoItems1 End_Procedure |
| 214 |
How can I display a tooltip when the cursor hovers the column
|
| 213 |
Is there any function to assign a key to a column instead using its name or capion
|
| 212 |
Is there any function to assign any extra data to a column
|
| 211 |
By default, the column gets sorted descending, when I first click its header. How can I change so the column gets sorted ascending when the user first clicks the column's header
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Variant voColumn Get ComAdd of hoColumns "Sort" to voColumn Handle hoColumn Get Create (RefClass(cComColumn)) to hoColumn Set pvComObject of hoColumn to voColumn Set ComDefaultSortOrder of hoColumn to True Send Destroy to hoColumn Send Destroy to hoColumns End_Procedure |
| 210 |
How can I specify the maximum width for the column, if I use WidthAutoResize property
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Variant voColumn Get ComAdd of hoColumns "Auto" to voColumn Handle hoColumn Get Create (RefClass(cComColumn)) to hoColumn Set pvComObject of hoColumn to voColumn Set ComWidthAutoResize of hoColumn to True Set ComMinWidthAutoResize of hoColumn to 32 Set ComMaxWidthAutoResize of hoColumn to 128 Send Destroy to hoColumn Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Get ComAddItem of hoItems 0 to Nothing Send Destroy to hoItems Variant voItems1 Get ComItems to voItems1 Handle hoItems1 Get Create (RefClass(cComItems)) to hoItems1 Set pvComObject of hoItems1 to voItems1 Get ComAddItem of hoItems1 1 to Nothing Send Destroy to hoItems1 End_Procedure |
| 209 |
How can I specify the minimum width for the column, if I use WidthAutoResize property
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Variant voColumn Get ComAdd of hoColumns "Auto" to voColumn Handle hoColumn Get Create (RefClass(cComColumn)) to hoColumn Set pvComObject of hoColumn to voColumn Set ComWidthAutoResize of hoColumn to True Set ComMinWidthAutoResize of hoColumn to 32 Send Destroy to hoColumn Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Get ComAddItem of hoItems 0 to Nothing Send Destroy to hoItems Variant voItems1 Get ComItems to voItems1 Handle hoItems1 Get Create (RefClass(cComItems)) to hoItems1 Set pvComObject of hoItems1 to voItems1 Get ComAddItem of hoItems1 1 to Nothing Send Destroy to hoItems1 End_Procedure |
| 208 |
Is there any option to resize the column based on its data, captions
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Variant voColumn Get ComAdd of hoColumns "A" to voColumn Handle hoColumn Get Create (RefClass(cComColumn)) to hoColumn Set pvComObject of hoColumn to voColumn Set ComWidthAutoResize of hoColumn to True Send Destroy to hoColumn Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Get ComAddItem of hoItems 0 to Nothing Send Destroy to hoItems Variant voItems1 Get ComItems to voItems1 Handle hoItems1 Get Create (RefClass(cComItems)) to hoItems1 Set pvComObject of hoItems1 to voItems1 Get ComAddItem of hoItems1 1 to Nothing Send Destroy to hoItems1 End_Procedure |
| 207 |
How can I align the icon in the column's header in the center
|
| 206 |
How do I align the icon in the column's header to the right
|
| 205 |
How do I show or hide the sorting icons, but still need sorting
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Variant voColumn Get ComAdd of hoColumns "Sorted" to voColumn Handle hoColumn Get Create (RefClass(cComColumn)) to hoColumn Set pvComObject of hoColumn to voColumn Set ComSortOrder of hoColumn to OLESortAscending Send Destroy to hoColumn Send Destroy to hoColumns Variant voColumns1 Get ComColumns to voColumns1 Handle hoColumns1 Get Create (RefClass(cComColumns)) to hoColumns1 Set pvComObject of hoColumns1 to voColumns1 Variant voColumn1 Get ComItem of hoColumns1 0 to voColumn1 Handle hoColumn1 Get Create (RefClass(cComColumn)) to hoColumn1 Set pvComObject of hoColumn1 to voColumn1 Set ComDisplaySortIcon of hoColumn1 to False Send Destroy to hoColumn1 Send Destroy to hoColumns1 End_Procedure |
| 204 |
How do I enable or disable the entire column
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "C1" to Nothing Send Destroy to hoColumns Variant voColumns1 Get ComColumns to voColumns1 Handle hoColumns1 Get Create (RefClass(cComColumns)) to hoColumns1 Set pvComObject of hoColumns1 to voColumns1 Variant voColumn Get ComAdd of hoColumns1 "Disabled" to voColumn Handle hoColumn Get Create (RefClass(cComColumn)) to hoColumn Set pvComObject of hoColumn to voColumn Set ComEnabled of hoColumn to False Send Destroy to hoColumn Send Destroy to hoColumns1 Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Set ComCellValue of hoItems (ComAddItem(hoItems,0)) 1 to "0.1" Send Destroy to hoItems Variant voItems1 Get ComItems to voItems1 Handle hoItems1 Get Create (RefClass(cComItems)) to hoItems1 Set pvComObject of hoItems1 to voItems1 Set ComCellValue of hoItems1 (ComAddItem(hoItems1,1)) 1 to "1.1" Send Destroy to hoItems1 End_Procedure |
| 203 |
How do I disable drag and drop columns
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Variant voColumn Get ComAdd of hoColumns "C1" to voColumn Handle hoColumn Get Create (RefClass(cComColumn)) to hoColumn Set pvComObject of hoColumn to voColumn Set ComAllowDragging of hoColumn to False Send Destroy to hoColumn Send Destroy to hoColumns Variant voColumns1 Get ComColumns to voColumns1 Handle hoColumns1 Get Create (RefClass(cComColumns)) to hoColumns1 Set pvComObject of hoColumns1 to voColumns1 Variant voColumn1 Get ComAdd of hoColumns1 "C2" to voColumn1 Handle hoColumn1 Get Create (RefClass(cComColumn)) to hoColumn1 Set pvComObject of hoColumn1 to voColumn1 Set ComAllowDragging of hoColumn1 to False Send Destroy to hoColumn1 Send Destroy to hoColumns1 End_Procedure |
| 202 |
How do I disable resizing a column at runtime
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Variant voColumn Get ComAdd of hoColumns "Unsizable" to voColumn Handle hoColumn Get Create (RefClass(cComColumn)) to hoColumn Set pvComObject of hoColumn to voColumn Set ComAllowSizing of hoColumn to False Send Destroy to hoColumn Send Destroy to hoColumns Variant voColumns1 Get ComColumns to voColumns1 Handle hoColumns1 Get Create (RefClass(cComColumns)) to hoColumns1 Set pvComObject of hoColumns1 to voColumns1 Get ComAdd of hoColumns1 "C2" to Nothing Send Destroy to hoColumns1 Variant voColumns2 Get ComColumns to voColumns2 Handle hoColumns2 Get Create (RefClass(cComColumns)) to hoColumns2 Set pvComObject of hoColumns2 to voColumns2 Get ComAdd of hoColumns2 "C3" to Nothing Send Destroy to hoColumns2 Variant voColumns3 Get ComColumns to voColumns3 Handle hoColumns3 Get Create (RefClass(cComColumns)) to hoColumns3 Set pvComObject of hoColumns3 to voColumns3 Get ComAdd of hoColumns3 "C4" to Nothing Send Destroy to hoColumns3 End_Procedure |
| 201 |
How can I align the column to the right, and its caption too
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Variant voColumn Get ComAdd of hoColumns "Column" to voColumn Handle hoColumn Get Create (RefClass(cComColumn)) to hoColumn Set pvComObject of hoColumn to voColumn Set ComAlignment of hoColumn to OLERightAlignment Set ComHeaderAlignment of hoColumn to OLERightAlignment Send Destroy to hoColumn Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Get ComAddItem of hoItems 0 to Nothing Send Destroy to hoItems Variant voItems1 Get ComItems to voItems1 Handle hoItems1 Get Create (RefClass(cComItems)) to hoItems1 Set pvComObject of hoItems1 to voItems1 Get ComAddItem of hoItems1 1 to Nothing Send Destroy to hoItems1 End_Procedure |
